package service;

import pojo.Student;

import java.sql.SQLException;
import java.util.List;

public interface StudentService {
    //查询所有学生信息
    List<Student> selectAll(String stuName,String stuNo,Integer sex,Integer pageIndex,Integer pageSize) throws SQLException;
    //获取总条数
    int total(String stuName,String stuNo,Integer sex) throws SQLException;
    //新增学生
    int addStudent(Student student);
    //修改学生信息
    int updateStudent(Student student);
    //通过id查询学生信息
    Student selectById(int stuId);
    //通过id删除学生信息
    int deleteById(int stuId);
    //通过学号查询学生信息
    Student selectByStuNo(String stuNo);
}
